
<%@page import="classes.Reports"%>
<%@page import="java.util.ArrayList"%>
<%@page contentType="text/html" pageEncoding="EUC-KR"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">
        <link rel="stylesheet" href="../css/table.css" type="text/css" />

        <title>Order Customer</title>
    </head>
    <body>
        <table id="table-1">
	<thead>
            <th>UserID</th>
                <th>First Name</th>
		<th>Last Name</th>
                <th>Address</th>
                <th>Telephone</th>
                <th>Email</th>
	</thead>
	<tbody>
	<%
            Reports.getConnection("SELECT * FROM brchung.person P, brchung.client C WHERE C.Id=P.SSN ORDER BY P.LastName;");
            ArrayList<String[]> rs=Reports.getResults(9,3,2,4,6,10);
            for(int i=0;i<rs.size();i++){
                out.print("<tr>");
                for(int j=0;j<6;j++)
                    out.print("<td>"+rs.get(i)[j]+"</td>");
                out.print("</tr>");
            }
        %>
	</tbody>
    </table>
    </body>
</html>
